﻿CREATE PROCEDURE [Auth].[GetUserByAccountID]
	@AccountID INT
WITH EXECUTE AS OWNER
AS
SET NOCOUNT ON;

SELECT AccountID,
       FirstName,
       LastName,
       DisplayName,
       Password,
       EmailAddress,
       AuthenticationSignInName,
       AuthenticationTypeID
  FROM Auth.Accounts
 WHERE AccountID = @AccountID;

SELECT AccountPropertyID,
       AccountID,
       PropertyName,
       PropertyValue
  FROM Auth.AccountProperties
 WHERE AccountID = @AccountID;